Pandas Profiling Report

Dataset statistics

Number of variables	31
Number of observations	278587
Missing cells	24663
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	65.9 MiB
Average record size in memory	248.0 B

Variable types

Numeric	7
Text	13
DateTime	3
Categorical	6
Unsupported	2

Alerts

`ACCESSORIAL_AMOUNT` is highly overall correlated with `ACCESSORIAL_CHARGE_AMOUNT` and 1 other fields	High correlation
`ACCESSORIAL_CHARGE_AMOUNT` is highly overall correlated with `ACCESSORIAL_AMOUNT` and 1 other fields	High correlation
`AMOUNT_PAID` is highly overall correlated with `ACCESSORIAL_AMOUNT` and 1 other fields	High correlation
`BILL_TYPE` is highly overall correlated with `SHIP_WEIGHT` and 1 other fields	High correlation
`IO_CODE` is highly overall correlated with `IO_CODE_DESCRIPTION` and 1 other fields	High correlation
`IO_CODE_DESCRIPTION` is highly overall correlated with `IO_CODE` and 1 other fields	High correlation
`SHIP_WEIGHT` is highly overall correlated with `BILL_TYPE`	High correlation
`SOLAR_MODE` is highly overall correlated with `BILL_TYPE`	High correlation
`Unnamed: 0` is highly overall correlated with `IO_CODE` and 1 other fields	High correlation
`BILL_TYPE` is highly imbalanced (52.3%)	Imbalance
`SHIPPER_NAME` is highly imbalanced (58.1%)	Imbalance
`DESTINATION_COUNTRY_CODE` has 2813 (1.0%) missing values	Missing
`DESTINATION_STATE` has 3286 (1.2%) missing values	Missing
`ORIGIN_STATE` has 6996 (2.5%) missing values	Missing
`PRO_NUMBER2` has 9317 (3.3%) missing values	Missing
`ACCESSORIAL_AMOUNT` is highly skewed (γ1 = 41.83294079)	Skewed
`ACCESSORIAL_CHARGE_AMOUNT` is highly skewed (γ1 = 22.23821765)	Skewed
`AMOUNT_PAID` is highly skewed (γ1 = 26.05638454)	Skewed
`SHIP_WEIGHT` is highly skewed (γ1 = 25.84201104)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`DESTINATION_ZIP` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ORIGIN_ZIP` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MILEAGE` has 128368 (46.1%) zeros	Zeros
`SHIP_WEIGHT` has 51581 (18.5%) zeros	Zeros

Reproduction

Analysis started	2024-02-16 06:34:07.856772
Analysis finished	2024-02-16 06:34:49.584754
Duration	41.73 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	278587
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139293

Minimum	0
Maximum	278586
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	13929.3
Q1	69646.5
median	139293
Q3	208939.5
95-th percentile	264656.7
Maximum	278586
Range	278586
Interquartile range (IQR)	139293

Descriptive statistics

Standard deviation	80421.284
Coefficient of variation (CV)	0.57735338
Kurtosis	-1.2
Mean	139293
Median Absolute Deviation (MAD)	69647
Skewness	1.1307088 × 10^-15
Sum	3.8805219 × 10¹⁰
Variance	6.4675829 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
185722	1	< 0.1%
185728	1	< 0.1%
185727	1	< 0.1%
185726	1	< 0.1%
185725	1	< 0.1%
185724	1	< 0.1%
185723	1	< 0.1%
185721	1	< 0.1%
187175	1	< 0.1%
Other values (278577)	278577	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
278586	1	< 0.1%
278585	1	< 0.1%
278584	1	< 0.1%
278583	1	< 0.1%
278582	1	< 0.1%
278581	1	< 0.1%
278580	1	< 0.1%
278579	1	< 0.1%
278578	1	< 0.1%
278577	1	< 0.1%

ACCESSORIAL_AMOUNT
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	41989
Distinct (%)	15.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1758.7773

Minimum	0.01314
Maximum	896151.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0.01314
5-th percentile	15.5052
Q1	52.56
median	233.09046
Q3	917.64504
95-th percentile	6718.3243
Maximum	896151.99
Range	896151.98
Interquartile range (IQR)	865.08504

Descriptive statistics

Standard deviation	13026.212
Coefficient of variation (CV)	7.4064019
Kurtosis	2312.6202
Mean	1758.7773
Median Absolute Deviation (MAD)	209.33334
Skewness	41.832941
Sum	4.8997249 × 10⁸
Variance	1.6968219 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
68.328	6096	2.2%
91.98	1361	0.5%
65.7	859	0.3%
51.7716	820	0.3%
64.55682	721	0.3%
785.6406	645	0.2%
328.5	441	0.2%
52.56	412	0.1%
131.4	406	0.1%
459.9	385	0.1%
Other values (41979)	266441	95.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01314	2	< 0.1%
0.07884	1	< 0.1%
1.0512	1	< 0.1%
1.15632	1	< 0.1%
1.26144	3	< 0.1%
1.314	2	< 0.1%
1.52424	1	< 0.1%
1.53738	1	< 0.1%
1.5768	1	< 0.1%
1.6425	1	< 0.1%

Value	Count	Frequency (%)
896151.9946	12	< 0.1%
846140.4319	12	< 0.1%
655493.9589	8	< 0.1%
592760.6161	6	< 0.1%
563688.5107	8	< 0.1%
533514.695	6	< 0.1%
448882.9772	12	< 0.1%
419682.4677	5	< 0.1%
392183.01	11	< 0.1%
353885.4945	4	< 0.1%

ACCESSORIAL_CHARGE_AMOUNT
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	42057
Distinct (%)	15.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	472.41597

Minimum	0.01314
Maximum	129950.04
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0.01314
5-th percentile	11.79972
Q1	23.54688
median	51.41682
Q3	166.10931
95-th percentile	1422.3748
Maximum	129950.04
Range	129950.03
Interquartile range (IQR)	142.56243

Descriptive statistics

Standard deviation	3259.0799
Coefficient of variation (CV)	6.8987506
Kurtosis	622.73217
Mean	472.41597
Median Absolute Deviation (MAD)	35.64882
Skewness	22.238218
Sum	1.3160895 × 10⁸
Variance	10621602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.28	12505	4.5%
13.14	12303	4.4%
19.71	7513	2.7%
51.41682	5962	2.1%
91.98	5917	2.1%
24.966	4872	1.7%
45.99	4305	1.5%
131.4	3964	1.4%
6.57	3631	1.3%
65.7	3005	1.1%
Other values (42047)	214610	77.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01314	234	0.1%
0.02628	1	< 0.1%
0.03942	6	< 0.1%
0.07884	4	< 0.1%
0.09198	1	< 0.1%
0.11826	1	< 0.1%
0.1314	2	< 0.1%
0.14454	1	< 0.1%
0.17082	2	< 0.1%
0.18396	1	< 0.1%

Value	Count	Frequency (%)
129950.0404	1	< 0.1%
129943.6544	1	< 0.1%
129775.239	1	< 0.1%
128271.8128	1	< 0.1%
127680.5128	1	< 0.1%
125749.8	1	< 0.1%
125746.9092	2	< 0.1%
125621.9872	2	< 0.1%
125317.8751	1	< 0.1%
123950.3296	1	< 0.1%

ACCESSORIAL_CHARGE_CODE
Text

Distinct	138
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	557174
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	FS
2nd row	FS
3rd row	FS
4th row	FS
5th row	FS

Value	Count	Frequency (%)
fs	128128	46.0%
br	21290	7.6%
ms	19033	6.8%
ha	14551	5.2%
pc	10135	3.6%
du	9265	3.3%
th	7685	2.8%
pf	7010	2.5%
mn	6112	2.2%
wv	5199	1.9%
Other values (128)	50179	18.0%

Most occurring characters

Value	Count	Frequency (%)
S	154107	27.7%
F	141198	25.3%
M	30497	5.5%
H	28364	5.1%
A	27607	5.0%
R	23782	4.3%
B	22672	4.1%
P	20884	3.7%
T	20631	3.7%
D	19487	3.5%
Other values (14)	67945	12.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	557174	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	154107	27.7%
F	141198	25.3%
M	30497	5.5%
H	28364	5.1%
A	27607	5.0%
R	23782	4.3%
B	22672	4.1%
P	20884	3.7%
T	20631	3.7%
D	19487	3.5%
Other values (14)	67945	12.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	557174	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	154107	27.7%
F	141198	25.3%
M	30497	5.5%
H	28364	5.1%
A	27607	5.0%
R	23782	4.3%
B	22672	4.1%
P	20884	3.7%
T	20631	3.7%
D	19487	3.5%
Other values (14)	67945	12.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	557174	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	154107	27.7%
F	141198	25.3%
M	30497	5.5%
H	28364	5.1%
A	27607	5.0%
R	23782	4.3%
B	22672	4.1%
P	20884	3.7%
T	20631	3.7%
D	19487	3.5%
Other values (14)	67945	12.2%

ACCESSORIAL_CHARGE_DESCRIPTION
Text

Distinct	138
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	30
Median length	28
Mean length	14.334642
Min length	3

Characters and Unicode

Total characters	3993445
Distinct characters	32
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	FUEL SURCHARGE
2nd row	FUEL SURCHARGE
3rd row	FUEL SURCHARGE
4th row	FUEL SURCHARGE
5th row	FUEL SURCHARGE

Value	Count	Frequency (%)
surcharge	128430	22.5%
fuel	128128	22.4%
charge	28741	5.0%
brokerage	21293	3.7%
custom	21290	3.7%
msc	19033	3.3%
chrgs	19033	3.3%
handling	14551	2.5%
fee	12452	2.2%
duty	11939	2.1%
Other values (203)	166195	29.1%

Most occurring characters

Value	Count	Frequency (%)
E	505318	12.7%
R	453241	11.3%
U	310563	7.8%
	292498	7.3%
A	289557	7.3%
C	288302	7.2%
S	260540	6.5%
G	250825	6.3%
H	216337	5.4%
L	175857	4.4%
Other values (22)	950407	23.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3687121	92.3%
Space Separator	292498	7.3%
Other Punctuation	13235	0.3%
Dash Punctuation	501	< 0.1%
Open Punctuation	45	< 0.1%
Close Punctuation	45	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	505318	13.7%
R	453241	12.3%
U	310563	8.4%
A	289557	7.9%
C	288302	7.8%
S	260540	7.1%
G	250825	6.8%
H	216337	5.9%
L	175857	4.8%
F	172995	4.7%
Other values (16)	763586	20.7%

Other Punctuation

Value	Count	Frequency (%)
/	13227	99.9%
&	8	0.1%

Space Separator

Value	Count	Frequency (%)
	292498	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	501	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	45	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	45	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3687121	92.3%
Common	306324	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	505318	13.7%
R	453241	12.3%
U	310563	8.4%
A	289557	7.9%
C	288302	7.8%
S	260540	7.1%
G	250825	6.8%
H	216337	5.9%
L	175857	4.8%
F	172995	4.7%
Other values (16)	763586	20.7%

Common

Value	Count	Frequency (%)
	292498	95.5%
/	13227	4.3%
-	501	0.2%
(	45	< 0.1%
)	45	< 0.1%
&	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3993445	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	505318	12.7%
R	453241	11.3%
U	310563	7.8%
	292498	7.3%
A	289557	7.3%
C	288302	7.2%
S	260540	6.5%
G	250825	6.3%
H	216337	5.4%
L	175857	4.4%
Other values (22)	950407	23.8%

AMOUNT_PAID
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	62830
Distinct (%)	22.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3580.7642

Minimum	0.01314
Maximum	934680.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0.01314
5-th percentile	111.40092
Q1	222.32223
median	734.7231
Q3	2479.4654
95-th percentile	11885.13
Maximum	934680.96
Range	934680.94
Interquartile range (IQR)	2257.1432

Descriptive statistics

Standard deviation	16659.259
Coefficient of variation (CV)	4.6524313
Kurtosis	1036.671
Mean	3580.7642
Median Absolute Deviation (MAD)	590.09112
Skewness	26.056385
Sum	9.9755435 × 10⁸
Variance	2.7753092 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
91.98	1324	0.5%
51.7716	816	0.3%
64.55682	719	0.3%
785.6406	649	0.2%
1859.31	564	0.2%
429.678	558	0.2%
65.7	522	0.2%
2168.1	428	0.2%
96.40818	321	0.1%
96.579	288	0.1%
Other values (62820)	272398	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01314	1	< 0.1%
0.07884	1	< 0.1%
1.314	1	< 0.1%
6.57	3	< 0.1%
6.59628	1	< 0.1%
7.34526	1	< 0.1%
8.6067	1	< 0.1%
8.65926	1	< 0.1%
9.90756	1	< 0.1%
11.826	1	< 0.1%

Value	Count	Frequency (%)
934680.958	1	< 0.1%
896151.9946	12	< 0.1%
846140.4319	12	< 0.1%
802120.1836	4	< 0.1%
655493.9589	8	< 0.1%
592760.6161	6	< 0.1%
563688.5501	8	< 0.1%
555631.1546	3	< 0.1%
533514.695	6	< 0.1%
461741.0323	6	< 0.1%

BILL_DATE
Date

Distinct	1497
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Minimum	2019-03-26 00:00:00
Maximum	2024-02-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

BILL_TYPE
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

LINEHAUL	225824
BALANCE DUE	50068
SEP. BILLED ACC.	2695

Length

Max length	16
Median length	8
Mean length	8.6165543
Min length	8

Characters and Unicode

Total characters	2400460
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LINEHAUL
2nd row	LINEHAUL
3rd row	LINEHAUL
4th row	LINEHAUL
5th row	LINEHAUL

Common Values

Value	Count	Frequency (%)
LINEHAUL	225824	81.1%
BALANCE DUE	50068	18.0%
SEP. BILLED ACC.	2695	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
linehaul	225824	67.6%
balance	50068	15.0%
due	50068	15.0%
sep	2695	0.8%
billed	2695	0.8%
acc	2695	0.8%

Most occurring characters

Value	Count	Frequency (%)
L	507106	21.1%
E	331350	13.8%
A	328655	13.7%
N	275892	11.5%
U	275892	11.5%
I	228519	9.5%
H	225824	9.4%
C	55458	2.3%
	55458	2.3%
B	52763	2.2%
Other values (4)	63543	2.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2339612	97.5%
Space Separator	55458	2.3%
Other Punctuation	5390	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	507106	21.7%
E	331350	14.2%
A	328655	14.0%
N	275892	11.8%
U	275892	11.8%
I	228519	9.8%
H	225824	9.7%
C	55458	2.4%
B	52763	2.3%
D	52763	2.3%
Other values (2)	5390	0.2%

Space Separator

Value	Count	Frequency (%)
	55458	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	5390	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2339612	97.5%
Common	60848	2.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	507106	21.7%
E	331350	14.2%
A	328655	14.0%
N	275892	11.8%
U	275892	11.8%
I	228519	9.8%
H	225824	9.7%
C	55458	2.4%
B	52763	2.3%
D	52763	2.3%
Other values (2)	5390	0.2%

Common

Value	Count	Frequency (%)
	55458	91.1%
.	5390	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2400460	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	507106	21.1%
E	331350	13.8%
A	328655	13.7%
N	275892	11.5%
U	275892	11.5%
I	228519	9.5%
H	225824	9.4%
C	55458	2.3%
	55458	2.3%
B	52763	2.2%
Other values (4)	63543	2.6%

CARRIER_MODE_DESCRIPTION
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

MOTOR	209718
AIR	68850
INTERNATIO	19

Length

Max length	10
Median length	5
Mean length	4.5060609
Min length	3

Characters and Unicode

Total characters	1255330
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MOTOR
2nd row	MOTOR
3rd row	MOTOR
4th row	MOTOR
5th row	MOTOR

Common Values

Value	Count	Frequency (%)
MOTOR	209718	75.3%
AIR	68850	24.7%
INTERNATIO	19	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
motor	209718	75.3%
air	68850	24.7%
internatio	19	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
O	419455	33.4%
R	278587	22.2%
T	209756	16.7%
M	209718	16.7%
I	68888	5.5%
A	68869	5.5%
N	38	< 0.1%
E	19	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1255330	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	419455	33.4%
R	278587	22.2%
T	209756	16.7%
M	209718	16.7%
I	68888	5.5%
A	68869	5.5%
N	38	< 0.1%
E	19	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1255330	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	419455	33.4%
R	278587	22.2%
T	209756	16.7%
M	209718	16.7%
I	68888	5.5%
A	68869	5.5%
N	38	< 0.1%
E	19	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1255330	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	419455	33.4%
R	278587	22.2%
T	209756	16.7%
M	209718	16.7%
I	68888	5.5%
A	68869	5.5%
N	38	< 0.1%
E	19	< 0.1%

CARRIER_NAME2
Text

Distinct	80
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	31
Median length	30
Mean length	18.913754
Min length	7

Characters and Unicode

Total characters	5269126
Distinct characters	50
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Young Ltd
2nd row	Young Ltd
3rd row	Young Ltd
4th row	Young Ltd
5th row	Young Ltd

Value	Count	Frequency (%)
and	144990	19.5%
hodges	67773	9.1%
weaver	67773	9.1%
lyons	67773	9.1%
taylor-newman	40926	5.5%
morales	34991	4.7%
anderson-esparza	31439	4.2%
torres	30715	4.1%
peck	30414	4.1%
inc	16618	2.2%
Other values (116)	209958	28.2%

Most occurring characters

Value	Count	Frequency (%)
e	538645	10.2%
	464783	8.8%
a	461560	8.8%
n	442305	8.4%
o	402202	7.6%
r	384976	7.3%
s	354879	6.7%
d	285446	5.4%
,	144968	2.8%
y	134464	2.6%
Other values (40)	1654898	31.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3837165	72.8%
Uppercase Letter	718448	13.6%
Space Separator	464783	8.8%
Other Punctuation	144968	2.8%
Dash Punctuation	103762	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	538645	14.0%
a	461560	12.0%
n	442305	11.5%
o	402202	10.5%
r	384976	10.0%
s	354879	9.2%
d	285446	7.4%
y	134464	3.5%
l	115911	3.0%
g	101682	2.6%
Other values (15)	615095	16.0%

Uppercase Letter

Value	Count	Frequency (%)
L	115629	16.1%
H	78254	10.9%
W	72963	10.2%
T	71731	10.0%
P	52690	7.3%
M	43039	6.0%
N	40926	5.7%
A	38138	5.3%
E	36061	5.0%
D	31661	4.4%
Other values (12)	137356	19.1%

Space Separator

Value	Count	Frequency (%)
	464783	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	144968	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	103762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4555613	86.5%
Common	713513	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	538645	11.8%
a	461560	10.1%
n	442305	9.7%
o	402202	8.8%
r	384976	8.5%
s	354879	7.8%
d	285446	6.3%
y	134464	3.0%
l	115911	2.5%
L	115629	2.5%
Other values (37)	1319596	29.0%

Common

Value	Count	Frequency (%)
	464783	65.1%
,	144968	20.3%
-	103762	14.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5269126	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	538645	10.2%
	464783	8.8%
a	461560	8.8%
n	442305	8.4%
o	402202	7.6%
r	384976	7.3%
s	354879	6.7%
d	285446	5.4%
,	144968	2.8%
y	134464	2.6%
Other values (40)	1654898	31.4%

DESTINATION_CITY
Text

Distinct	2078
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	20
Median length	19
Mean length	8.5738315
Min length	3

Characters and Unicode

Total characters	2388558
Distinct characters	33
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	345 ?
Unique (%)	0.1%

Sample

1st row	BROKEN ARROW
2nd row	SAN DIEGO
3rd row	SAN DIEGO
4th row	SAN DIEGO
5th row	SAN DIEGO

Value	Count	Frequency (%)
san	99933	24.1%
diego	98645	23.8%
desoto	16431	4.0%
fairburn	15427	3.7%
bitozeves	14435	3.5%
mabank	8955	2.2%
zatec	8338	2.0%
zebrak	7192	1.7%
houston	6758	1.6%
gardena	5685	1.4%
Other values (2149)	133101	32.1%

Most occurring characters

Value	Count	Frequency (%)
E	269633	11.3%
A	244147	10.2%
O	241044	10.1%
N	228250	9.6%
I	187523	7.9%
S	179826	7.5%
D	141776	5.9%
	136534	5.7%
G	131238	5.5%
R	118707	5.0%
Other values (23)	509880	21.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2251966	94.3%
Space Separator	136534	5.7%
Open Punctuation	20	< 0.1%
Dash Punctuation	16	< 0.1%
Other Punctuation	16	< 0.1%
Decimal Number	6	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	269633	12.0%
A	244147	10.8%
O	241044	10.7%
N	228250	10.1%
I	187523	8.3%
S	179826	8.0%
D	141776	6.3%
G	131238	5.8%
R	118707	5.3%
T	79103	3.5%
Other values (16)	430719	19.1%

Other Punctuation

Value	Count	Frequency (%)
.	10	62.5%
,	6	37.5%

Decimal Number

Value	Count	Frequency (%)
9	3	50.0%
0	3	50.0%

Space Separator

Value	Count	Frequency (%)
	136534	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	20	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2251966	94.3%
Common	136592	5.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	269633	12.0%
A	244147	10.8%
O	241044	10.7%
N	228250	10.1%
I	187523	8.3%
S	179826	8.0%
D	141776	6.3%
G	131238	5.8%
R	118707	5.3%
T	79103	3.5%
Other values (16)	430719	19.1%

Common

Value	Count	Frequency (%)
	136534	> 99.9%
(	20	< 0.1%
-	16	< 0.1%
.	10	< 0.1%
,	6	< 0.1%
9	3	< 0.1%
0	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2388558	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	269633	11.3%
A	244147	10.2%
O	241044	10.1%
N	228250	9.6%
I	187523	7.9%
S	179826	7.5%
D	141776	5.9%
	136534	5.7%
G	131238	5.5%
R	118707	5.0%
Other values (23)	509880	21.3%

DESTINATION_COUNTRY_CODE
Text

MISSING

Distinct	98
Distinct (%)	< 0.1%
Missing	2813
Missing (%)	1.0%
Memory size	2.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	551548
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Value	Count	Frequency (%)
us	206598	74.9%
cz	33761	12.2%
be	8303	3.0%
au	7034	2.6%
de	4166	1.5%
cn	2966	1.1%
gb	2587	0.9%
uk	1378	0.5%
ca	882	0.3%
hk	788	0.3%
Other values (88)	7311	2.7%

Most occurring characters

Value	Count	Frequency (%)
U	215203	39.0%
S	207543	37.6%
C	38135	6.9%
Z	34264	6.2%
E	13732	2.5%
B	11268	2.0%
A	8449	1.5%
D	5150	0.9%
N	3944	0.7%
K	3540	0.6%
Other values (16)	10320	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	551548	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	215203	39.0%
S	207543	37.6%
C	38135	6.9%
Z	34264	6.2%
E	13732	2.5%
B	11268	2.0%
A	8449	1.5%
D	5150	0.9%
N	3944	0.7%
K	3540	0.6%
Other values (16)	10320	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	551548	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	215203	39.0%
S	207543	37.6%
C	38135	6.9%
Z	34264	6.2%
E	13732	2.5%
B	11268	2.0%
A	8449	1.5%
D	5150	0.9%
N	3944	0.7%
K	3540	0.6%
Other values (16)	10320	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	551548	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	215203	39.0%
S	207543	37.6%
C	38135	6.9%
Z	34264	6.2%
E	13732	2.5%
B	11268	2.0%
A	8449	1.5%
D	5150	0.9%
N	3944	0.7%
K	3540	0.6%
Other values (16)	10320	1.9%

DESTINATION_NAME2
Text

Distinct	4857
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	25
Median length	23
Mean length	13.90963
Min length	7

Characters and Unicode

Total characters	3875042
Distinct characters	54
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1526 ?
Unique (%)	0.5%

Sample

1st row	Christopher Shepard
2nd row	Ashley Cruz
3rd row	Jeremy Colon
4th row	Ashley Cruz
5th row	Ashley Cruz

Value	Count	Frequency (%)
christopher	71518	12.8%
shepard	70419	12.6%
brown	43095	7.7%
ryan	42861	7.7%
ashley	27221	4.9%
cruz	26182	4.7%
michael	15021	2.7%
carl	12841	2.3%
ramsey	12828	2.3%
clark	12320	2.2%
Other values (1439)	225443	40.3%

Most occurring characters

Value	Count	Frequency (%)
r	392493	10.1%
e	333851	8.6%
h	308031	7.9%
	281162	7.3%
a	279669	7.2%
i	199794	5.2%
o	198445	5.1%
n	192285	5.0%
s	176130	4.5%
l	167970	4.3%
Other values (44)	1345212	34.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3030966	78.2%
Uppercase Letter	561766	14.5%
Space Separator	281162	7.3%
Other Punctuation	1148	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	392493	12.9%
e	333851	11.0%
h	308031	10.2%
a	279669	9.2%
i	199794	6.6%
o	198445	6.5%
n	192285	6.3%
s	176130	5.8%
l	167970	5.5%
p	154036	5.1%
Other values (16)	628262	20.7%

Uppercase Letter

Value	Count	Frequency (%)
C	142670	25.4%
S	86964	15.5%
R	71124	12.7%
B	49798	8.9%
A	36956	6.6%
M	34928	6.2%
J	20954	3.7%
T	18063	3.2%
D	15996	2.8%
K	12112	2.2%
Other values (16)	72201	12.9%

Space Separator

Value	Count	Frequency (%)
	281162	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1148	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3592732	92.7%
Common	282310	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	392493	10.9%
e	333851	9.3%
h	308031	8.6%
a	279669	7.8%
i	199794	5.6%
o	198445	5.5%
n	192285	5.4%
s	176130	4.9%
l	167970	4.7%
p	154036	4.3%
Other values (42)	1190028	33.1%

Common

Value	Count	Frequency (%)
	281162	99.6%
.	1148	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3875042	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	392493	10.1%
e	333851	8.6%
h	308031	7.9%
	281162	7.3%
a	279669	7.2%
i	199794	5.2%
o	198445	5.1%
n	192285	5.0%
s	176130	4.5%
l	167970	4.3%
Other values (44)	1345212	34.7%

DESTINATION_STATE
Text

MISSING

Distinct	112
Distinct (%)	< 0.1%
Missing	3286
Missing (%)	1.2%
Memory size	2.1 MiB

Length

Max length	2
Median length	2
Mean length	1.9999818
Min length	1

Characters and Unicode

Total characters	550597
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	OK
2nd row	CA
3rd row	CA
4th row	CA
5th row	CA

Value	Count	Frequency (%)
ca	122454	44.5%
xx	59558	21.6%
tx	43569	15.8%
ga	17178	6.2%
ok	4920	1.8%
cz	4293	1.6%
la	3793	1.4%
az	2269	0.8%
pa	1057	0.4%
oh	970	0.4%
Other values (102)	15240	5.5%

Most occurring characters

Value	Count	Frequency (%)
X	162780	29.6%
A	149185	27.1%
C	128469	23.3%
T	44514	8.1%
G	17657	3.2%
O	7095	1.3%
Z	6592	1.2%
K	5916	1.1%
L	5463	1.0%
N	3164	0.6%
Other values (17)	19762	3.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	550557	> 99.9%
Currency Symbol	40	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
X	162780	29.6%
A	149185	27.1%
C	128469	23.3%
T	44514	8.1%
G	17657	3.2%
O	7095	1.3%
Z	6592	1.2%
K	5916	1.1%
L	5463	1.0%
N	3164	0.6%
Other values (16)	19722	3.6%

Currency Symbol

Value	Count	Frequency (%)
$	40	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	550557	> 99.9%
Common	40	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	162780	29.6%
A	149185	27.1%
C	128469	23.3%
T	44514	8.1%
G	17657	3.2%
O	7095	1.3%
Z	6592	1.2%
K	5916	1.1%
L	5463	1.0%
N	3164	0.6%
Other values (16)	19722	3.6%

Common

Value	Count	Frequency (%)
$	40	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	550597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
X	162780	29.6%
A	149185	27.1%
C	128469	23.3%
T	44514	8.1%
G	17657	3.2%
O	7095	1.3%
Z	6592	1.2%
K	5916	1.1%
L	5463	1.0%
N	3164	0.6%
Other values (17)	19762	3.6%

DESTINATION_ZIP
Unsupported

REJECTED UNSUPPORTED

Missing	153
Missing (%)	0.1%
Memory size	2.1 MiB

IO_CODE
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

1	105345
2	104060
4	39929
3	29253

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	278587
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

Most occurring characters

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	278587	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	278587	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	278587	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	105345	37.8%
2	104060	37.4%
4	39929	14.3%
3	29253	10.5%

IO_CODE_DESCRIPTION
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Inbound	105345
Outbound	104060
Third Party	39929
Interfacility	29253

Length

Max length	13
Median length	11
Mean length	8.5768647
Min length	7

Characters and Unicode

Total characters	2389403
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Inbound
2nd row	Inbound
3rd row	Inbound
4th row	Inbound
5th row	Inbound

Common Values

Value	Count	Frequency (%)
Inbound	105345	37.8%
Outbound	104060	37.4%
Third Party	39929	14.3%
Interfacility	29253	10.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
inbound	105345	33.1%
outbound	104060	32.7%
third	39929	12.5%
party	39929	12.5%
interfacility	29253	9.2%

Most occurring characters

Value	Count	Frequency (%)
n	344003	14.4%
u	313465	13.1%
d	249334	10.4%
b	209405	8.8%
o	209405	8.8%
t	202495	8.5%
I	134598	5.6%
r	109111	4.6%
O	104060	4.4%
i	98435	4.1%
Other values (10)	415092	17.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2030958	85.0%
Uppercase Letter	318516	13.3%
Space Separator	39929	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	344003	16.9%
u	313465	15.4%
d	249334	12.3%
b	209405	10.3%
o	209405	10.3%
t	202495	10.0%
r	109111	5.4%
i	98435	4.8%
a	69182	3.4%
y	69182	3.4%
Other values (5)	156941	7.7%

Uppercase Letter

Value	Count	Frequency (%)
I	134598	42.3%
O	104060	32.7%
T	39929	12.5%
P	39929	12.5%

Space Separator

Value	Count	Frequency (%)
	39929	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2349474	98.3%
Common	39929	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	344003	14.6%
u	313465	13.3%
d	249334	10.6%
b	209405	8.9%
o	209405	8.9%
t	202495	8.6%
I	134598	5.7%
r	109111	4.6%
O	104060	4.4%
i	98435	4.2%
Other values (9)	375163	16.0%

Common

Value	Count	Frequency (%)
	39929	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2389403	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	344003	14.4%
u	313465	13.1%
d	249334	10.4%
b	209405	8.8%
o	209405	8.8%
t	202495	8.5%
I	134598	5.6%
r	109111	4.6%
O	104060	4.4%
i	98435	4.1%
Other values (10)	415092	17.4%

MILEAGE
Real number (ℝ)

ZEROS

Distinct	2537
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	600.88452

Minimum	0
Maximum	4814
Zeros	128368
Zeros (%)	46.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	31
Q3	1107
95-th percentile	2302
Maximum	4814
Range	4814
Interquartile range (IQR)	1107

Descriptive statistics

Standard deviation	826.57897
Coefficient of variation (CV)	1.3756037
Kurtosis	0.22777737
Mean	600.88452
Median Absolute Deviation (MAD)	31
Skewness	1.1795863
Sum	1.6739862 × 10⁸
Variance	683232.79
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	128368	46.1%
1102	6804	2.4%
1345	4079	1.5%
2118	2864	1.0%
112	2576	0.9%
352	2507	0.9%
1024	2410	0.9%
117	2400	0.9%
1474	2390	0.9%
1392	2313	0.8%
Other values (2527)	121876	43.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	128368	46.1%
2	4	< 0.1%
3	1	< 0.1%
4	963	0.3%
5	6	< 0.1%
6	79	< 0.1%
7	56	< 0.1%
8	384	0.1%
9	1596	0.6%
10	694	0.2%

Value	Count	Frequency (%)
4814	2	< 0.1%
4653	3	< 0.1%
4651	12	< 0.1%
4541	2	< 0.1%
4432	2	< 0.1%
4394	7	< 0.1%
4359	7	< 0.1%
4332	2	< 0.1%
4320	19	< 0.1%
4262	8	< 0.1%

ORIGIN_CITY
Text

Distinct	1962
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	20
Median length	18
Mean length	8.2064238
Min length	3

Characters and Unicode

Total characters	2286203
Distinct characters	39
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	371 ?
Unique (%)	0.1%

Sample

1st row	MOUNTAIN TOP
2nd row	SHAKOPEE
3rd row	ALEXANDER
4th row	FLORENCE
5th row	FLORENCE

Value	Count	Frequency (%)
san	50201	13.7%
diego	48853	13.4%
fairburn	36962	10.1%
tijuana	27079	7.4%
desoto	25277	6.9%
ontario	6934	1.9%
mabank	6763	1.9%
houston	5434	1.5%
channelview	4857	1.3%
south	4690	1.3%
Other values (2006)	148333	40.6%

Most occurring characters

Value	Count	Frequency (%)
A	279592	12.2%
N	242970	10.6%
O	217165	9.5%
I	185174	8.1%
E	182973	8.0%
R	150669	6.6%
S	133085	5.8%
T	117794	5.2%
D	106385	4.7%
U	93625	4.1%
Other values (29)	576771	25.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2197926	96.1%
Space Separator	87888	3.8%
Decimal Number	204	< 0.1%
Dash Punctuation	137	< 0.1%
Other Punctuation	34	< 0.1%
Open Punctuation	11	< 0.1%
Close Punctuation	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	279592	12.7%
N	242970	11.1%
O	217165	9.9%
I	185174	8.4%
E	182973	8.3%
R	150669	6.9%
S	133085	6.1%
T	117794	5.4%
D	106385	4.8%
U	93625	4.3%
Other values (16)	488494	22.2%

Decimal Number

Value	Count	Frequency (%)
1	85	41.7%
0	48	23.5%
3	38	18.6%
2	31	15.2%
6	2	1.0%

Other Punctuation

Value	Count	Frequency (%)
,	20	58.8%
.	7	20.6%
/	5	14.7%
"	2	5.9%

Space Separator

Value	Count	Frequency (%)
	87888	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	137	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	11	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2197926	96.1%
Common	88277	3.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	279592	12.7%
N	242970	11.1%
O	217165	9.9%
I	185174	8.4%
E	182973	8.3%
R	150669	6.9%
S	133085	6.1%
T	117794	5.4%
D	106385	4.8%
U	93625	4.3%
Other values (16)	488494	22.2%

Common

Value	Count	Frequency (%)
	87888	99.6%
-	137	0.2%
1	85	0.1%
0	48	0.1%
3	38	< 0.1%
2	31	< 0.1%
,	20	< 0.1%
(	11	< 0.1%
.	7	< 0.1%
/	5	< 0.1%
Other values (3)	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2286203	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	279592	12.2%
N	242970	10.6%
O	217165	9.5%
I	185174	8.1%
E	182973	8.0%
R	150669	6.6%
S	133085	5.8%
T	117794	5.2%
D	106385	4.7%
U	93625	4.1%
Other values (29)	576771	25.2%

ORIGIN_COUNTRY_CODE
Text

Distinct	84
Distinct (%)	< 0.1%
Missing	1714
Missing (%)	0.6%
Memory size	2.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	553746
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Value	Count	Frequency (%)
us	218086	78.8%
mx	28519	10.3%
ca	7642	2.8%
cz	3050	1.1%
jp	2600	0.9%
de	2222	0.8%
it	1907	0.7%
tr	1793	0.6%
gb	1489	0.5%
uk	1223	0.4%
Other values (74)	8342	3.0%

Most occurring characters

Value	Count	Frequency (%)
U	219855	39.7%
S	219740	39.7%
M	28813	5.2%
X	28523	5.2%
C	11618	2.1%
A	9141	1.7%
T	4665	0.8%
E	3854	0.7%
I	3165	0.6%
Z	3083	0.6%
Other values (16)	21289	3.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	553746	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	219855	39.7%
S	219740	39.7%
M	28813	5.2%
X	28523	5.2%
C	11618	2.1%
A	9141	1.7%
T	4665	0.8%
E	3854	0.7%
I	3165	0.6%
Z	3083	0.6%
Other values (16)	21289	3.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	553746	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	219855	39.7%
S	219740	39.7%
M	28813	5.2%
X	28523	5.2%
C	11618	2.1%
A	9141	1.7%
T	4665	0.8%
E	3854	0.7%
I	3165	0.6%
Z	3083	0.6%
Other values (16)	21289	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	553746	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	219855	39.7%
S	219740	39.7%
M	28813	5.2%
X	28523	5.2%
C	11618	2.1%
A	9141	1.7%
T	4665	0.8%
E	3854	0.7%
I	3165	0.6%
Z	3083	0.6%
Other values (16)	21289	3.8%

ORIGIN_NAME2
Text

Distinct	4931
Distinct (%)	1.8%
Missing	1
Missing (%)	< 0.1%
Memory size	2.1 MiB

Length

Max length	28
Median length	26
Mean length	13.033458
Min length	7

Characters and Unicode

Total characters	3630939
Distinct characters	54
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1600 ?
Unique (%)	0.6%

Sample

1st row	Derrick Castro
2nd row	Jason Harvey
3rd row	Julia Nielsen
4th row	Richard Wright
5th row	Richard Wright

Value	Count	Frequency (%)
nguyen	36781	6.5%
kristie	36690	6.5%
gregory	23676	4.2%
avery	23153	4.1%
sanchez	16425	2.9%
roy	16361	2.9%
mary	14356	2.5%
calderon	14201	2.5%
lisa	13354	2.4%
eric	13104	2.3%
Other values (1451)	355436	63.1%

Most occurring characters

Value	Count	Frequency (%)
e	367138	10.1%
r	303769	8.4%
	284951	7.8%
a	258688	7.1%
n	236268	6.5%
i	221608	6.1%
o	199356	5.5%
y	176315	4.9%
l	160662	4.4%
s	150508	4.1%
Other values (44)	1271676	35.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2775280	76.4%
Uppercase Letter	568011	15.6%
Space Separator	284951	7.8%
Other Punctuation	2697	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	367138	13.2%
r	303769	10.9%
a	258688	9.3%
n	236268	8.5%
i	221608	8.0%
o	199356	7.2%
y	176315	6.4%
l	160662	5.8%
s	150508	5.4%
t	139637	5.0%
Other values (16)	561331	20.2%

Uppercase Letter

Value	Count	Frequency (%)
S	57110	10.1%
A	52236	9.2%
K	45669	8.0%
N	43817	7.7%
C	41718	7.3%
M	37843	6.7%
L	35071	6.2%
H	34390	6.1%
B	32625	5.7%
G	31509	5.5%
Other values (16)	156023	27.5%

Space Separator

Value	Count	Frequency (%)
	284951	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	2697	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3343291	92.1%
Common	287648	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	367138	11.0%
r	303769	9.1%
a	258688	7.7%
n	236268	7.1%
i	221608	6.6%
o	199356	6.0%
y	176315	5.3%
l	160662	4.8%
s	150508	4.5%
t	139637	4.2%
Other values (42)	1129342	33.8%

Common

Value	Count	Frequency (%)
	284951	99.1%
.	2697	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3630939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	367138	10.1%
r	303769	8.4%
	284951	7.8%
a	258688	7.1%
n	236268	6.5%
i	221608	6.1%
o	199356	5.5%
y	176315	4.9%
l	160662	4.4%
s	150508	4.1%
Other values (44)	1271676	35.0%

ORIGIN_STATE
Text

MISSING

Distinct	100
Distinct (%)	< 0.1%
Missing	6996
Missing (%)	2.5%
Memory size	2.1 MiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	543182
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	PA
2nd row	MN
3rd row	AR
4th row	KY
5th row	KY

Value	Count	Frequency (%)
ca	84115	31.0%
tx	50417	18.6%
ga	40728	15.0%
xx	16992	6.3%
bc	14238	5.2%
mx	12638	4.7%
on	5657	2.1%
oh	4832	1.8%
ok	4565	1.7%
az	4302	1.6%
Other values (90)	33107	12.2%

Most occurring characters

Value	Count	Frequency (%)
A	137381	25.3%
C	103359	19.0%
X	97039	17.9%
T	53216	9.8%
G	40821	7.5%
M	18481	3.4%
O	16819	3.1%
B	14998	2.8%
N	14073	2.6%
I	7805	1.4%
Other values (16)	39190	7.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	543182	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	137381	25.3%
C	103359	19.0%
X	97039	17.9%
T	53216	9.8%
G	40821	7.5%
M	18481	3.4%
O	16819	3.1%
B	14998	2.8%
N	14073	2.6%
I	7805	1.4%
Other values (16)	39190	7.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	543182	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	137381	25.3%
C	103359	19.0%
X	97039	17.9%
T	53216	9.8%
G	40821	7.5%
M	18481	3.4%
O	16819	3.1%
B	14998	2.8%
N	14073	2.6%
I	7805	1.4%
Other values (16)	39190	7.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	543182	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	137381	25.3%
C	103359	19.0%
X	97039	17.9%
T	53216	9.8%
G	40821	7.5%
M	18481	3.4%
O	16819	3.1%
B	14998	2.8%
N	14073	2.6%
I	7805	1.4%
Other values (16)	39190	7.2%

ORIGIN_ZIP
Unsupported

REJECTED UNSUPPORTED

Missing	148
Missing (%)	0.1%
Memory size	2.1 MiB

PROCESS_DATE
Date

Distinct	1045
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Minimum	2020-01-06 00:00:00
Maximum	2024-02-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

PRO_NUMBER2
Real number (ℝ)

MISSING

Distinct	147178
Distinct (%)	54.7%
Missing	9317
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	5.0010035 × 10¹²

Minimum	1.3514963 × 10⁸
Maximum	9.9999377 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	1.3514963 × 10⁸
5-th percentile	4.9159138 × 10¹¹
Q1	2.4984058 × 10¹²
median	5.0039166 × 10¹²
Q3	7.5013252 × 10¹²
95-th percentile	9.5041179 × 10¹²
Maximum	9.9999377 × 10¹²
Range	9.9998025 × 10¹²
Interquartile range (IQR)	5.0029195 × 10¹²

Descriptive statistics

Standard deviation	2.8890583 × 10¹²
Coefficient of variation (CV)	0.57769573
Kurtosis	-1.2002091
Mean	5.0010035 × 10¹²
Median Absolute Deviation (MAD)	2.5010961 × 10¹²
Skewness	-0.00099756212
Sum	1.3466202 × 10¹⁸
Variance	8.3466581 × 10²⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.067741336 × 10¹²	19	< 0.1%
5.450729213 × 10¹²	12	< 0.1%
5.674512345 × 10¹²	12	< 0.1%
1.438908826 × 10¹²	12	< 0.1%
6.006171343 × 10¹²	12	< 0.1%
7.200775697 × 10¹²	12	< 0.1%
9.554701198 × 10¹²	12	< 0.1%
6.907628391 × 10¹¹	12	< 0.1%
4.302833979 × 10¹²	12	< 0.1%
3.424880772 × 10¹¹	12	< 0.1%
Other values (147168)	269143	96.6%
(Missing)	9317	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
135149629	1	< 0.1%
175591785	1	< 0.1%
213976710	1	< 0.1%
402685065	2	< 0.1%
479960157	1	< 0.1%
497546968	1	< 0.1%
523138549	1	< 0.1%
553233603	1	< 0.1%
655018917	1	< 0.1%
690112892	1	< 0.1%

Value	Count	Frequency (%)
9.999937663 × 10¹²	1	< 0.1%
9.999858228 × 10¹²	1	< 0.1%
9.999853088 × 10¹²	1	< 0.1%
9.999796206 × 10¹²	1	< 0.1%
9.999718983 × 10¹²	1	< 0.1%
9.999698537 × 10¹²	1	< 0.1%
9.999620617 × 10¹²	1	< 0.1%
9.999465428 × 10¹²	1	< 0.1%
9.999380799 × 10¹²	1	< 0.1%
9.99926455 × 10¹²	1	< 0.1%

RECEIVER
Text

Distinct	5008
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	20
Median length	19
Mean length	16.102833
Min length	1

Characters and Unicode

Total characters	4486040
Distinct characters	47
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1625 ?
Unique (%)	0.6%

Sample

1st row	SOLAR TURBINES
2nd row	SOLAR TURBINES KEARN
3rd row	TURBOTEC SOLAR TURBI
4th row	SOLAR TURBINES KEARN
5th row	SOLAR TURBINES KEARN

Value	Count	Frequency (%)
solar	182693	26.7%
turbines	175915	25.7%
harbo	42502	6.2%
kearn	27383	4.0%
inc	14444	2.1%
overh	12819	1.9%
turbotec	9780	1.4%
c/o	7707	1.1%
ups-scs	7675	1.1%
reman	6555	1.0%
Other values (4390)	197536	28.8%

Most occurring characters

Value	Count	Frequency (%)
R	567649	12.7%
S	438447	9.8%
	406555	9.1%
A	359775	8.0%
O	340462	7.6%
E	330377	7.4%
N	292475	6.5%
I	274393	6.1%
T	264994	5.9%
B	254506	5.7%
Other values (37)	956407	21.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4058404	90.5%
Space Separator	406555	9.1%
Dash Punctuation	10931	0.2%
Other Punctuation	9503	0.2%
Decimal Number	624	< 0.1%
Open Punctuation	22	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	567649	14.0%
S	438447	10.8%
A	359775	8.9%
O	340462	8.4%
E	330377	8.1%
N	292475	7.2%
I	274393	6.8%
T	264994	6.5%
B	254506	6.3%
L	243451	6.0%
Other values (16)	691875	17.0%

Decimal Number

Value	Count	Frequency (%)
2	232	37.2%
3	162	26.0%
0	64	10.3%
1	54	8.7%
8	35	5.6%
6	27	4.3%
4	21	3.4%
5	20	3.2%
9	5	0.8%
7	4	0.6%

Other Punctuation

Value	Count	Frequency (%)
/	8109	85.3%
&	737	7.8%
%	638	6.7%
.	13	0.1%
'	3	< 0.1%
;	3	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	15	68.2%
[	7	31.8%

Space Separator

Value	Count	Frequency (%)
	406555	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10931	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4058404	90.5%
Common	427636	9.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	567649	14.0%
S	438447	10.8%
A	359775	8.9%
O	340462	8.4%
E	330377	8.1%
N	292475	7.2%
I	274393	6.8%
T	264994	6.5%
B	254506	6.3%
L	243451	6.0%
Other values (16)	691875	17.0%

Common

Value	Count	Frequency (%)
	406555	95.1%
-	10931	2.6%
/	8109	1.9%
&	737	0.2%
%	638	0.1%
2	232	0.1%
3	162	< 0.1%
0	64	< 0.1%
1	54	< 0.1%
8	35	< 0.1%
Other values (11)	119	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4486040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	567649	12.7%
S	438447	9.8%
	406555	9.1%
A	359775	8.0%
O	340462	7.6%
E	330377	7.4%
N	292475	6.5%
I	274393	6.1%
T	264994	5.9%
B	254506	5.7%
Other values (37)	956407	21.3%

SHIPPER
Text

Distinct	5101
Distinct (%)	1.8%
Missing	1
Missing (%)	< 0.1%
Memory size	2.1 MiB

Length

Max length	30
Median length	28
Mean length	16.400386
Min length	2

Characters and Unicode

Total characters	4568918
Distinct characters	58
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1701 ?
Unique (%)	0.6%

Sample

1st row	WYMAN GORDON
2nd row	ROSEMOUNT INC
3rd row	PPG INDUSTRIES
4th row	REGAL BELOIT
5th row	REGAL BELOIT

Value	Count	Frequency (%)
solar	113143	16.2%
turbines	112488	16.2%
inc	42884	6.2%
overhaul	23152	3.3%
turbotec	22165	3.2%
turbo	14594	2.1%
tecnologi	14189	2.0%
mesa	12853	1.8%
kearny	12802	1.8%
drive	11951	1.7%
Other values (4449)	316056	45.4%

Most occurring characters

Value	Count	Frequency (%)
R	484667	10.6%
	417909	9.1%
E	359138	7.9%
S	342833	7.5%
O	341627	7.5%
A	340089	7.4%
I	297961	6.5%
T	293624	6.4%
N	291025	6.4%
L	243436	5.3%
Other values (48)	1156609	25.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4123779	90.3%
Space Separator	417909	9.1%
Dash Punctuation	13468	0.3%
Other Punctuation	13212	0.3%
Decimal Number	273	< 0.1%
Lowercase Letter	198	< 0.1%
Open Punctuation	43	< 0.1%
Close Punctuation	36	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	484667	11.8%
E	359138	8.7%
S	342833	8.3%
O	341627	8.3%
A	340089	8.2%
I	297961	7.2%
T	293624	7.1%
N	291025	7.1%
L	243436	5.9%
U	229768	5.6%
Other values (16)	899611	21.8%

Lowercase Letter

Value	Count	Frequency (%)
i	28	14.1%
a	28	14.1%
n	28	14.1%
l	16	8.1%
o	14	7.1%
j	14	7.1%
c	14	7.1%
m	14	7.1%
d	14	7.1%
r	14	7.1%

Decimal Number

Value	Count	Frequency (%)
0	110	40.3%
2	36	13.2%
1	36	13.2%
3	35	12.8%
6	15	5.5%
4	13	4.8%
5	12	4.4%
8	6	2.2%
9	5	1.8%
7	5	1.8%

Other Punctuation

Value	Count	Frequency (%)
/	10984	83.1%
&	1503	11.4%
.	421	3.2%
%	281	2.1%
,	12	0.1%
'	6	< 0.1%
;	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	417909	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13468	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	43	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	36	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4123977	90.3%
Common	444941	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	484667	11.8%
E	359138	8.7%
S	342833	8.3%
O	341627	8.3%
A	340089	8.2%
I	297961	7.2%
T	293624	7.1%
N	291025	7.1%
L	243436	5.9%
U	229768	5.6%
Other values (27)	899809	21.8%

Common

Value	Count	Frequency (%)
	417909	93.9%
-	13468	3.0%
/	10984	2.5%
&	1503	0.3%
.	421	0.1%
%	281	0.1%
0	110	< 0.1%
(	43	< 0.1%
)	36	< 0.1%
2	36	< 0.1%
Other values (11)	150	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4568918	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	484667	10.6%
	417909	9.1%
E	359138	7.9%
S	342833	7.5%
O	341627	7.5%
A	340089	7.4%
I	297961	6.5%
T	293624	6.4%
N	291025	6.4%
L	243436	5.3%
Other values (48)	1156609	25.3%

SHIPPER_NAME
Categorical

IMBALANCE

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

SOLAR TURBINES - SAN DIEGO	184939
SOLAR TURBINES - DESOTO	34444
SOLAR TURBINES-FAIRBURN	23765
SOLAR TURBINES - MABANK	12972
SOLAR TURBINES-AIR SAN DIEGO	7240
Other values (14)	15227

Length

Max length	30
Median length	26
Mean length	25.249348
Min length	23

Characters and Unicode

Total characters	7034140
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SOLAR TURBINES - SAN DIEGO
2nd row	SOLAR TURBINES - SAN DIEGO
3rd row	SOLAR TURBINES - SAN DIEGO
4th row	SOLAR TURBINES - SAN DIEGO
5th row	SOLAR TURBINES - SAN DIEGO

Common Values

Value	Count	Frequency (%)
SOLAR TURBINES - SAN DIEGO	184939	66.4%
SOLAR TURBINES - DESOTO	34444	12.4%
SOLAR TURBINES-FAIRBURN	23765	8.5%
SOLAR TURBINES - MABANK	12972	4.7%
SOLAR TURBINES-AIR SAN DIEGO	7240	2.6%
SOLAR TURBINES-TURBO FAB	4466	1.6%
SOLAR TURBINES-HARBOR DRIVE	3431	1.2%
SOLAR TURBINES-TURBOTEC	2793	1.0%
SOLAR TURBINES-AIR FAIRBURN	2691	1.0%
SOLAR TURBINES-KEARNY MESA	786	0.3%
Other values (9)	1060	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
solar	278587	22.6%
	232355	18.8%
turbines	232355	18.8%
san	192179	15.6%
diego	192179	15.6%
desoto	34628	2.8%
turbines-fairburn	23765	1.9%
mabank	13113	1.1%
turbines-air	10640	0.9%
turbines-turbo	4466	0.4%
Other values (20)	19854	1.6%

Most occurring characters

Value	Count	Frequency (%)
	955534	13.6%
S	784977	11.2%
R	641073	9.1%
O	551638	7.8%
A	544294	7.7%
E	513883	7.3%
I	511445	7.3%
N	511428	7.3%
B	333837	4.7%
T	323315	4.6%
Other values (14)	1362716	19.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5800019	82.5%
Space Separator	955534	13.6%
Dash Punctuation	278587	4.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	784977	13.5%
R	641073	11.1%
O	551638	9.5%
A	544294	9.4%
E	513883	8.9%
I	511445	8.8%
N	511428	8.8%
B	333837	5.8%
T	323315	5.6%
U	312478	5.4%
Other values (12)	771651	13.3%

Space Separator

Value	Count	Frequency (%)
	955534	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	278587	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5800019	82.5%
Common	1234121	17.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	784977	13.5%
R	641073	11.1%
O	551638	9.5%
A	544294	9.4%
E	513883	8.9%
I	511445	8.8%
N	511428	8.8%
B	333837	5.8%
T	323315	5.6%
U	312478	5.4%
Other values (12)	771651	13.3%

Common

Value	Count	Frequency (%)
	955534	77.4%
-	278587	22.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7034140	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	955534	13.6%
S	784977	11.2%
R	641073	9.1%
O	551638	7.8%
A	544294	7.7%
E	513883	7.3%
I	511445	7.3%
N	511428	7.3%
B	333837	4.7%
T	323315	4.6%
Other values (14)	1362716	19.4%

SHIP_DATE
Date

Distinct	1466
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Minimum	2020-01-01 00:00:00
Maximum	2024-02-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

SHIP_WEIGHT
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	13633
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3400.4959

Minimum	0
Maximum	1421500
Zeros	51581
Zeros (%)	18.5%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	95
median	401.234
Q3	1492.504
95-th percentile	17815
Maximum	1421500
Range	1421500
Interquartile range (IQR)	1397.504

Descriptive statistics

Standard deviation	15863.319
Coefficient of variation (CV)	4.6650017
Kurtosis	1291.2691
Mean	3400.4959
Median Absolute Deviation (MAD)	401.234
Skewness	25.842011
Sum	9.4733395 × 10⁸
Variance	2.516449 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	51581	18.5%
1	2559	0.9%
2.205	1937	0.7%
100	1235	0.4%
200	1106	0.4%
300	1094	0.4%
150	1021	0.4%
400	965	0.3%
1500	938	0.3%
500	903	0.3%
Other values (13623)	215248	77.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51581	18.5%
1	2559	0.9%
2	145	0.1%
2.205	1937	0.7%
3	88	< 0.1%
4	128	< 0.1%
4.409	563	0.2%
5	132	< 0.1%
6	51	< 0.1%
6.614	322	0.1%

Value	Count	Frequency (%)
1421500	1	< 0.1%
1158465.326	6	< 0.1%
973639	2	< 0.1%
971503.29	1	< 0.1%
672356.538	4	< 0.1%
663641.813	5	< 0.1%
532968	3	< 0.1%
527277.208	2	< 0.1%
500683.299	9	< 0.1%
454129.078	5	< 0.1%

SOLAR_MODE
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	234
Missing (%)	0.1%
Memory size	2.1 MiB

LTL	119510
AE	71562
TL	26326
FF	22269
CU	22231
Other values (7)	16455

Length

Max length	3
Median length	2
Mean length	2.4519154
Min length	2

Characters and Unicode

Total characters	682498
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LTL
2nd row	LTL
3rd row	LTL
4th row	LTL
5th row	LTL

Common Values

Value	Count	Frequency (%)
LTL	119510	42.9%
AE	71562	25.7%
TL	26326	9.4%
FF	22269	8.0%
CU	22231	8.0%
HH	6998	2.5%
OCN	6251	2.2%
CR	2939	1.1%
PA	164	0.1%
MV	40	< 0.1%
Other values (2)	63	< 0.1%
(Missing)	234	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ltl	119510	42.9%
ae	71562	25.7%
tl	26326	9.5%
ff	22269	8.0%
cu	22231	8.0%
hh	6998	2.5%
ocn	6251	2.2%
cr	2939	1.1%
pa	164	0.1%
mv	40	< 0.1%
Other values (2)	63	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
L	265346	38.9%
T	145836	21.4%
A	71757	10.5%
E	71562	10.5%
F	44538	6.5%
C	31421	4.6%
U	22231	3.3%
H	13996	2.1%
O	6251	0.9%
N	6251	0.9%
Other values (5)	3309	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	682498	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	265346	38.9%
T	145836	21.4%
A	71757	10.5%
E	71562	10.5%
F	44538	6.5%
C	31421	4.6%
U	22231	3.3%
H	13996	2.1%
O	6251	0.9%
N	6251	0.9%
Other values (5)	3309	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	682498	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	265346	38.9%
T	145836	21.4%
A	71757	10.5%
E	71562	10.5%
F	44538	6.5%
C	31421	4.6%
U	22231	3.3%
H	13996	2.1%
O	6251	0.9%
N	6251	0.9%
Other values (5)	3309	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	682498	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	265346	38.9%
T	145836	21.4%
A	71757	10.5%
E	71562	10.5%
F	44538	6.5%
C	31421	4.6%
U	22231	3.3%
H	13996	2.1%
O	6251	0.9%
N	6251	0.9%
Other values (5)	3309	0.5%

Auto

Heatmap
Table

	ACCESSORIAL_AMOUNT	ACCESSORIAL_CHARGE_AMOUNT	AMOUNT_PAID	BILL_TYPE	CARRIER_MODE_DESCRIPTION	IO_CODE	IO_CODE_DESCRIPTION	MILEAGE	PRO_NUMBER2	SHIPPER_NAME	SHIP_WEIGHT	SOLAR_MODE	Unnamed: 0
ACCESSORIAL_AMOUNT	1.000	0.600	0.890	0.048	0.006	0.017	0.017	-0.475	-0.005	0.000	0.012	0.053	0.056
ACCESSORIAL_CHARGE_AMOUNT	0.600	1.000	0.576	0.090	0.013	0.014	0.014	-0.036	-0.001	0.011	0.216	0.064	0.050
AMOUNT_PAID	0.890	0.576	1.000	0.027	0.017	0.022	0.022	-0.294	-0.002	0.014	0.285	0.057	0.088
BILL_TYPE	0.048	0.090	0.027	1.000	0.035	0.250	0.250	0.416	0.007	0.262	0.599	0.515	0.164
CARRIER_MODE_DESCRIPTION	0.006	0.013	0.017	0.035	1.000	0.153	0.153	0.256	-0.001	0.343	0.084	0.415	-0.145
IO_CODE	0.017	0.014	0.022	0.250	0.153	1.000	1.000	-0.053	-0.003	0.274	0.039	0.399	0.824
IO_CODE_DESCRIPTION	0.017	0.014	0.022	0.250	0.153	1.000	1.000	-0.064	-0.003	0.274	0.095	0.399	0.943
MILEAGE	-0.475	-0.036	-0.294	0.416	0.256	-0.053	-0.064	1.000	0.008	0.161	0.365	0.193	-0.078
PRO_NUMBER2	-0.005	-0.001	-0.002	0.007	-0.001	-0.003	-0.003	0.008	1.000	0.010	0.002	0.010	-0.003
SHIPPER_NAME	0.000	0.011	0.014	0.262	0.343	0.274	0.274	0.161	0.010	1.000	-0.067	0.177	-0.051
SHIP_WEIGHT	0.012	0.216	0.285	0.599	0.084	0.039	0.095	0.365	0.002	-0.067	1.000	0.064	0.068
SOLAR_MODE	0.053	0.064	0.057	0.515	0.415	0.399	0.399	0.193	0.010	0.177	0.064	1.000	-0.112
Unnamed: 0	0.056	0.050	0.088	0.164	-0.145	0.824	0.943	-0.078	-0.003	-0.051	0.068	-0.112	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Unnamed: 0	ACCESSORIAL_AMOUNT	ACCESSORIAL_CHARGE_AMOUNT	ACCESSORIAL_CHARGE_CODE	ACCESSORIAL_CHARGE_DESCRIPTION	AMOUNT_PAID	BILL_DATE	BILL_TYPE	CARRIER_MODE_DESCRIPTION	CARRIER_NAME2	DESTINATION_CITY	DESTINATION_COUNTRY_CODE	DESTINATION_NAME2	DESTINATION_STATE	DESTINATION_ZIP	IO_CODE	IO_CODE_DESCRIPTION	MILEAGE	ORIGIN_CITY	ORIGIN_COUNTRY_CODE	ORIGIN_NAME2	ORIGIN_STATE	ORIGIN_ZIP	PROCESS_DATE	PRO_NUMBER2	RECEIVER	SHIPPER	SHIPPER_NAME	SHIP_DATE	SHIP_WEIGHT	SOLAR_MODE
0	0	116.23644	116.23644	FS	FUEL SURCHARGE	784.27404	2021-09-28	LINEHAUL	MOTOR	Young Ltd	BROKEN ARROW	US	Christopher Shepard	OK	74012	1	Inbound	1237	MOUNTAIN TOP	US	Derrick Castro	PA	18707	2021-10-12	3.186389e+12	SOLAR TURBINES	WYMAN GORDON	SOLAR TURBINES - SAN DIEGO	2021-09-28	2830.0	LTL
1	1	32.77116	32.77116	FS	FUEL SURCHARGE	221.09364	2021-09-24	LINEHAUL	MOTOR	Young Ltd	SAN DIEGO	US	Ashley Cruz	CA	92123	1	Inbound	1899	SHAKOPEE	US	Jason Harvey	MN	55379	2021-10-12	7.564392e+12	SOLAR TURBINES KEARN	ROSEMOUNT INC	SOLAR TURBINES - SAN DIEGO	2021-09-24	549.0	LTL
2	2	48.34206	38.48706	FS	FUEL SURCHARGE	268.29252	2021-10-08	LINEHAUL	MOTOR	Young Ltd	SAN DIEGO	US	Jeremy Colon	CA	92154	1	Inbound	1640	ALEXANDER	US	Julia Nielsen	AR	72002	2021-10-19	3.416653e+12	TURBOTEC SOLAR TURBI	PPG INDUSTRIES	SOLAR TURBINES - SAN DIEGO	2021-10-08	688.0	LTL
3	3	22.25916	22.25916	FS	FUEL SURCHARGE	151.68816	2021-09-08	LINEHAUL	MOTOR	Young Ltd	SAN DIEGO	US	Ashley Cruz	CA	92123	1	Inbound	2166	FLORENCE	US	Richard Wright	KY	41042	2021-10-12	5.769524e+12	SOLAR TURBINES KEARN	REGAL BELOIT	SOLAR TURBINES - SAN DIEGO	2021-09-08	220.0	LTL
4	4	22.52196	22.52196	FS	FUEL SURCHARGE	151.95096	2021-09-24	LINEHAUL	MOTOR	Young Ltd	SAN DIEGO	US	Ashley Cruz	CA	92123	1	Inbound	2166	FLORENCE	US	Richard Wright	KY	41042	2021-10-12	5.837051e+12	SOLAR TURBINES KEARN	REGAL BELOIT	SOLAR TURBINES - SAN DIEGO	2021-09-24	252.0	LTL
5	5	25.37334	25.37334	FS	FUEL SURCHARGE	171.22734	2021-09-30	LINEHAUL	MOTOR	Young Ltd	FAIRBURN	US	Michael Clark	GA	30213	1	Inbound	444	FLORENCE	US	Richard Wright	KY	41042	2021-10-12	7.619189e+12	SOLAR TURBINES INC	REGAL BELOIT	SOLAR TURBINES - SAN DIEGO	2021-09-30	640.0	LTL
6	6	23.82282	23.82282	FS	FUEL SURCHARGE	160.72848	2021-09-28	LINEHAUL	MOTOR	Young Ltd	FAIRBURN	US	Michael Clark	GA	30213	1	Inbound	2118	SAN DIEGO	US	Roy Sanchez	CA	92154	2021-10-12	3.652718e+12	SOLAR TURBINES INC	SOLAR TURBINES	SOLAR TURBINES - SAN DIEGO	2021-09-28	305.0	LTL
7	7	22.65336	22.65336	FS	FUEL SURCHARGE	152.08236	2021-10-05	LINEHAUL	MOTOR	Young Ltd	BROKEN ARROW	US	Christopher Shepard	OK	74012	1	Inbound	759	WAUKESHA	US	Robert James	WI	53186	2021-10-19	4.614602e+12	SOLAR TURBINES	METAL TEK	SOLAR TURBINES - SAN DIEGO	2021-10-05	300.0	LTL
8	8	130.26996	130.26996	FS	FUEL SURCHARGE	874.67724	2021-10-04	LINEHAUL	MOTOR	Young Ltd	BROKEN ARROW	US	Christopher Shepard	OK	74012	1	Inbound	971	YORK	US	Melissa Hayes	SC	29745	2021-10-19	3.399017e+12	SOLAR TURBINES	FOMAS INC	SOLAR TURBINES - SAN DIEGO	2021-10-04	3750.0	LTL
9	9	21.27366	21.27366	FS	FUEL SURCHARGE	142.81866	2021-10-06	LINEHAUL	MOTOR	Young Ltd	FAIRBURN	US	Michael Clark	GA	30213	1	Inbound	266	GREENEVILLE	US	Wayne Martin	TN	37743	2021-10-19	6.518610e+12	SOLAR TURBINES INC	DONALDSON CO IN	SOLAR TURBINES - SAN DIEGO	2021-10-06	1044.0	LTL

	Unnamed: 0	ACCESSORIAL_AMOUNT	ACCESSORIAL_CHARGE_AMOUNT	ACCESSORIAL_CHARGE_CODE	ACCESSORIAL_CHARGE_DESCRIPTION	AMOUNT_PAID	BILL_DATE	BILL_TYPE	CARRIER_MODE_DESCRIPTION	CARRIER_NAME2	DESTINATION_CITY	DESTINATION_COUNTRY_CODE	DESTINATION_NAME2	DESTINATION_STATE	DESTINATION_ZIP	IO_CODE	IO_CODE_DESCRIPTION	MILEAGE	ORIGIN_CITY	ORIGIN_COUNTRY_CODE	ORIGIN_NAME2	ORIGIN_STATE	ORIGIN_ZIP	PROCESS_DATE	PRO_NUMBER2	RECEIVER	SHIPPER	SHIPPER_NAME	SHIP_DATE	SHIP_WEIGHT	SOLAR_MODE
278577	278577	43.30944	43.30944	FS	FUEL SURCHARGE	309.03966	2021-04-08	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	TULSA	US	Jose Harvey	OK	74117	4	Third Party	672	SHAKOPEE	US	Pamela Dominguez	MN	55379	2021-04-26	NaN	BERENDSEN FLUID	CONTINENTAL HYD	SOLAR TURBINES - SAN DIEGO	2021-04-08	1660.0	LTL
278578	278578	34.13772	34.13772	FS	FUEL SURCHARGE	243.57618	2021-04-05	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	CARSON	US	Donna Lee	CA	90745	4	Third Party	2603	HONEOYE FALLS	US	Michael Young	NY	14472	2021-04-26	NaN	CAL-COAST PACKI	GRAVER TECHNOLO	SOLAR TURBINES - SAN DIEGO	2021-04-05	742.0	LTL
278579	278579	60.98274	60.98274	FS	FUEL SURCHARGE	437.45688	2021-04-13	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	ROCKFORD	US	Vanessa Blair	IL	61104	4	Third Party	967	CORSICANA	US	Tina Pierce	TX	75110	2021-04-27	NaN	DIAL MACHINE	OIL CITY IRON W	SOLAR TURBINES - SAN DIEGO	2021-04-13	2505.0	LTL
278580	278580	15.13728	15.13728	FS	FUEL SURCHARGE	108.03708	2021-04-09	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	PHOENIX	US	Kathleen Fields	AZ	85040	4	Third Party	352	SAN DIEGO	US	Richard Davis	CA	92154	2021-04-26	NaN	CHROMALLOY ARIZ	CHROMALLOY PGTC	SOLAR TURBINES - SAN DIEGO	2021-04-09	150.0	LTL
278581	278581	57.13272	57.13272	FS	FUEL SURCHARGE	407.66850	2021-04-07	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	FOUNTAIN VALLEY	US	Javier Harrington	CA	92708	4	Third Party	1423	CORSICANA	US	Tina Pierce	TX	75110	2021-04-27	NaN	OMNI METAL FINI	OIL CITY IRON W	SOLAR TURBINES - SAN DIEGO	2021-04-07	1973.0	LTL
278582	278582	15.61032	15.61032	FS	FUEL SURCHARGE	111.40092	2021-04-07	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	ESCONDIDO	US	Patricia Lloyd	CA	92029	4	Third Party	1401	CORSICANA	US	Tina Pierce	TX	75110	2021-04-27	NaN	PRICE PRODUCTS	OIL CITY IRON W	SOLAR TURBINES - SAN DIEGO	2021-04-07	299.0	LTL
278583	278583	16.25418	16.25418	FS	FUEL SURCHARGE	116.55180	2021-04-12	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	PHOENIX	US	Kathleen Fields	AZ	85040	4	Third Party	352	SAN DIEGO	US	Heather Miles	CA	92154	2021-04-27	NaN	CHROMALLOY ARIZ	UPS SUPPLY CHAI	SOLAR TURBINES - SAN DIEGO	2021-04-12	114.0	LTL
278584	278584	15.99138	15.99138	FS	FUEL SURCHARGE	114.68592	2021-04-13	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	SAN MARCOS	US	Barbara Richards	CA	92069	4	Third Party	36	SAN DIEGO	US	Heather Miles	CA	92154	2021-04-27	NaN	BLACK OXIDE SER	UPS SUPPLY CHAI	SOLAR TURBINES - SAN DIEGO	2021-04-13	268.0	LTL
278585	278585	40.95738	15.99138	FS	FUEL SURCHARGE	139.65192	2021-04-13	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	HUNTINGTON PARK	US	Erika Stark	CA	90255	4	Third Party	120	SAN DIEGO	US	Heather Miles	CA	92154	2021-04-27	NaN	BODYCOTE THERMA	UPS SUPPLY CHAI	SOLAR TURBINES - SAN DIEGO	2021-04-13	205.0	LTL
278586	278586	74.22786	74.22786	FS	FUEL SURCHARGE	529.59456	2021-04-08	LINEHAUL	MOTOR	Hodges, Lyons and Weaver	CARROLLTON	US	Nicole Banks	TX	75006	4	Third Party	1633	NORTH HAVEN	US	Grant Harper	CT	6473	2021-04-27	NaN	AMERICAN CRATIN	SAFT AMERICA	SOLAR TURBINES - SAN DIEGO	2021-04-08	1865.0	LTL

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Open Punctuation